Skip to main content

Get-DataTableRow

SYNOPSIS​

SYNTAX​

Get-DataTableRow [[-DataTable] <DataTable>] [[-Query] <String>] [-ProgressAction <ActionPreference>]
 [<CommonParameters>]

DESCRIPTION​

Retreive rows from DataTable

EXAMPLES​

EXAMPLE 1​

Get-DataTableRow -DataTable $DataTable -Query '[OrderID] = 123456789'

This example demonstrates how to retreive rows from data table.

PARAMETERS​

-DataTable​

Pass the data table object to get rows from

Type: DataTable
Parameter Sets: (All)
Aliases:

Required: False
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Query​

Define a query.

-like : like -gt : > -lt : < -eq : =

Values should be enclosed with single qoutation marks Columns should not be enclosed with quotation marks

Type: String
Parameter Sets: (All)
Aliases: SQLQuery

Required: False
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ProgressAction​

{{ Fill ProgressAction Description }}

Type: ActionPreference
Parameter Sets: (All)
Aliases: proga

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters​

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS​

OUTPUTS​

NOTES​

EDIT THIS DOC​

This page was auto-generated from the powershell command comment based help. To edit the content of this page, update the script file comment based help on github Github